﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ReporteSuspensiones.aspx.cs" Inherits="Reportes_ArchivosReportes_ReporteSuspensiones" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<link href="../../TVMedia3Web/site.css" rel="stylesheet" type="text/css" />
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Página sin título</title>
</head>
<body>
    
    <div>
  
    
    </div>
    <img border="0" src="../../images/logo.jpg" /><table align="center" bgcolor="#000088"
        border="0" cellpadding="0" cellspacing="0" width="100%">
        <tr>
            <td class="page-title-blanco" width="80%">
                <b>Sistema de Consultas</b></td>
            <td align="right">
                <a href="salir.asp">
                    <img alt="Salir del Sistema" border="0" src="../../images/ico_salir.gif" /></a>&nbsp;
            </td>
        </tr>
    </table>
    &nbsp;
                <table align="center" bgcolor="#f3ac42" border="1" cellpadding="3" cellspacing="0" >
                    <tr>
                        <td  width: 338px;">
                            <form id="form1" runat="server">
                                <table border="0" cellpadding="1" cellspacing="1"  align="center" style="width: 504px">
                                    <tr>
                                        <td class="fld-title" style="width: 157px; height: 24px; text-align: right;">
                                            <asp:Label ID="Label4" runat="server" Text="Motivo de suspesión:" Width="152px"></asp:Label></td>
                                        <td style="width: 673px; height: 24px; text-align: left;">
                                            <asp:DropDownList ID="ddlMotivoSuspension" runat="server" DataSourceID="sqldsMotivosSuspension"
                                               DataValueField="id_motivo_suspender"  DataTextField="nombre"  Width="160px" OnDataBound="AddNullValue" >
                                            </asp:DropDownList></td>
                                    
                                   
                                    </tr>
                                    <tr>
                                        <td class="fld-title" style="width: 157px; text-align: right;">
                                            <asp:Label ID="Label5" runat="server" Text="Ventanilla:" Width="104px"></asp:Label></td>
                                        <td style="width: 673px; text-align: left" >
                                            <asp:DropDownList ID="ddlVentanilla" runat="server" Width="72px" DataSourceID="sqldsVentanilla" DataTextField="id_ventanilla" DataValueField="id_ventanilla" OnDataBound="AddNullValue">
                                            </asp:DropDownList>
                                        </td>
                                        
                         
                                    </tr>
                                  
                                    <tr>
                                        <td class="fld-title" style="width: 157px; height: 24px; text-align: right;">
                                            <asp:Label ID="Label2" runat="server" Text="Fecha Inicio:" Width="104px"></asp:Label></td>
                                        <td colspan="3" style="text-align: left; height: 24px;" width="50%">
                                            <asp:DropDownList ID="ddlDiaInicio" runat="server" Width="39px">
                                            </asp:DropDownList>
                                            <asp:DropDownList ID="ddlMesInicio" runat="server" Width="39px">
                                            </asp:DropDownList>
                                            <asp:DropDownList ID="ddlAnhoInicio" runat="server" Width="64px">
                                            </asp:DropDownList>
                                            <asp:Label ID="Label3" runat="server" Text=" (dd/mm/aaaa)  "></asp:Label></td>
                                    </tr>
                                    <tr>
                                        <td style="width: 157px; text-align: right;" class="fld-title" >
                                            <asp:Label ID="Label1" runat="server" Text="Fecha Fin:" Width="67px"></asp:Label></td>
                                            <td style="width: 673px; text-align: left">
                                            <asp:DropDownList ID="ddlDiaFin" runat="server" Width="39px"></asp:DropDownList>
                                            <asp:DropDownList ID="ddlMesFin" runat="server" Width="39px"></asp:DropDownList>
                                            <asp:DropDownList ID="ddlAnhoFin" runat="server" Width="64px"></asp:DropDownList>
                                                <asp:Label ID="Label6" runat="server" Text=" (dd/mm/aaaa)  "></asp:Label></td>
                                    </tr>
                                    <tr>
                                        <td align="center" colspan="4" style="height: 26px">
                                            <asp:Button ID="btnConsultar" runat="server" CssClass="Bsbttn" OnClick="btnConsultar_Click"
                                                Text="Generar Reporte" /></td>
                                    </tr>
                                    <tr>
                                    </tr>
                                </table>
                            </form>
                        </td>
                    </tr>
                </table><asp:SqlDataSource ID="sqldsMotivosSuspension" runat="server" ConnectionString="<%$ ConnectionStrings:bdtvmediaSConnectionString %>"
        SelectCommand="SELECT * FROM [MOTIVO_SUSPENDER]"></asp:SqlDataSource>
    <asp:SqlDataSource ID="sqldsVentanilla" runat="server" ConnectionString="<%$ ConnectionStrings:bdtvmediaSConnectionString %>"
        SelectCommand="SELECT [id_ventanilla] FROM [VENTANILLA] ORDER BY [id_ventanilla]">
    </asp:SqlDataSource>

</body>
</html>
